package com.xyy.saas.payment.service;

import com.xyy.saas.payment.dao.model.PayFinanceRefundPlan;
import com.xyy.saas.payment.exception.PaymentException;
import com.xyy.saas.payment.manage.cores.vo.ResultPageVo;
import com.xyy.saas.payment.pojo.dto.ProfitSharingSettleDTO;
import com.xyy.saas.payment.pojo.vo.PayFinanceRefundPlanVo;
import com.xyy.saas.payment.pojo.vo.PinganRepaymentPlanParamVO;
import com.xyy.saas.payment.pojo.vo.UserAccountWithdrawalDTO;

import java.text.ParseException;
import java.util.List;

public interface PinganLoanService {

    void transferToPlatformCommissionAccount(UserAccountWithdrawalDTO withdrawalDTO) throws PaymentException;

    void settle(ProfitSharingSettleDTO settleDTO) throws PaymentException;

    String queryPinganFrozenAmount(String userId) throws PaymentException;

    String queryPinganWithdrawableBalance(String userId) throws PaymentException;

    /**
     * 平安贷还款计划金额对账，验证平安贷还款计划是否与业务数据金额一致
     */
    void checkLoanAmount(boolean sendWarn);

    ResultPageVo<List<PayFinanceRefundPlanVo>> queryByPage(PinganRepaymentPlanParamVO param);

    /**
     * 下载历史还款计划
     */
    String downloadLoanHuanKuanFileHistory(String startFileDate, boolean analy) throws ParseException, InterruptedException;

    /**
     * 还款计划下载
     */
    void downloadLoanHuanKuanFile(String fileDate, boolean sendMsg);

    void onlyDownloadLoanHuanKuanFile(String fileDate);

    List<PayFinanceRefundPlan> getContent(String filePath);

    List<PayFinanceRefundPlan> export(PinganRepaymentPlanParamVO param);

    /**
     * 处理历史数据：上线前的excel数据
     */
    void dealHistory(boolean db, boolean clearDb);

    String HISTORY_EXCEL =
            "ACCAL202303130819885068176218164,1,2,20230315,20230315,1,2230,2230,2229.26,2229.26,0.74,0.74,0,0,0,0\r\n" +
            "ACCAL202303130819885068176218164,1,2,20230421,20230421,1,0.74,0.74,0.74,0.74,0,0,0,0,0,0\r\n" +
            "ACCAL202303130819896835325590876,1,1,20230421,20230421,1,15849.86,15849.86,15747.5,15747.5,102.36,102.36,0,0,0,0\r\n" +
            "ACCAL202303130819930739642095668,1,1,20230421,20230421,1,2314.45,2314.45,2299.5,2299.5,14.95,14.95,0,0,0,0\r\n" +
            "ACCAL202303130819934060436295920,1,1,20230421,20230421,1,13170.05,13170.05,13085,13085,85.05,85.05,0,0,0,0\r\n" +
            "ACCAL202303130819934523617475932,1,1,20230421,20230421,1,6061.14,6061.14,6022,6022,39.14,39.14,0,0,0,0\r\n" +
            "ACCAL202303130819935422893032264,1,1,20230421,20230421,1,31047.61,31047.61,30847.1,30847.1,200.51,200.51,0,0,0,0\r\n" +
            "ACCAL202303140820331451396020276,1,1,20230421,20230421,1,13660.98,13660.98,13575,13575,85.98,85.98,0,0,0,0\r\n" +
            "ACCAL202303140820331581654325300,1,1,20230421,20230421,1,21841.46,21841.46,21704,21704,137.46,137.46,0,0,0,0\r\n" +
            "ACCAL202303150820645091714301276,1,1,20230421,20230421,1,4194.71,4194.71,4169,4169,25.71,25.71,0,0,0,0\r\n" +
            "ACCAL202303150820645301475643632,1,1,20230421,20230421,1,1785.95,1785.95,1775,1775,10.95,10.95,0,0,0,0\r\n" +
            "ACCAL202303150820667323777701940,1,1,20230421,20230421,1,2897.76,2897.76,2880,2880,17.76,17.76,0,0,0,0\r\n" +
            "ACCAL202303150820667463855013212,1,1,20230421,20230421,1,2866.57,2866.57,2849,2849,17.57,17.57,0,0,0,0\r\n" +
            "ACCAL202303150820667579386976308,1,1,20230421,20230421,1,2193.44,2193.44,2180,2180,13.44,13.44,0,0,0,0\r\n" +
            "ACCAL202303170821343912765192964,1,1,20230421,20230421,1,2011.67,2011.67,2000,2000,11.67,11.67,0,0,0,0\r\n" +
            "ACCAL202303170821344036962587044,1,1,20230421,20230421,1,4043.45,4043.45,4020,4020,23.45,23.45,0,0,0,0\r\n" +
            "ACCAL202303170821344209440756132,1,1,20230421,20230421,1,2330.52,2330.52,2317,2317,13.52,13.52,0,0,0,0\r\n" +
            "ACCAL202303170821368222854565272,1,1,20230421,20230421,1,2088.11,2088.11,2076,2076,12.11,12.11,0,0,0,0\r\n" +
            "ACCAL202303170821368370771039108,1,1,20230421,20230421,1,3510.36,3510.36,3490,3490,20.36,20.36,0,0,0,0\r\n" +
            "ACCAL202303200822483420386578852,1,1,20230421,20230421,1,14264.67,14264.67,14189,14189,75.67,75.67,0,0,0,0\r\n" +
            "ACCAL202303200822483522668876196,1,1,20230421,20230421,1,1789.49,1789.49,1780,1780,9.49,9.49,0,0,0,0\r\n" +
            "ACCAL202303210822809215671882148,1,1,20230421,20230421,1,4221.7,4221.7,4200,4200,21.7,21.7,0,0,0,0\r\n" +
            "ACCAL202303210822809368596205988,1,1,20230421,20230421,1,3429.47,3429.47,3411.84,3411.84,17.63,17.63,0,0,0,0\r\n" +
            "ACCAL202303210822809614269179476,1,1,20230421,20230421,1,3998.55,3998.55,3978,3978,20.55,20.55,0,0,0,0\r\n" +
            "ACCAL202303210822810076447919512,1,1,20230421,20230421,1,5588.73,5588.73,5560,5560,28.73,28.73,0,0,0,0\r\n" +
            "ACCAL202303210822810193703883172,1,2,20230325,20230325,1,2640,2640,2638.24,2638.24,1.76,1.76,0,0,0,0\r\n" +
            "ACCAL202303210822810193703883172,1,2,20230421,20230421,1,1.77,1.77,1.76,1.76,0.01,0.01,0,0,0,0\r\n" +
            "ACCAL202303210822810332401275780,1,1,20230421,20230421,1,2030.44,2030.44,2020,2020,10.44,10.44,0,0,0,0\r\n" +
            "ACCAL202303210822810457290722712,1,1,20230421,20230421,1,2451.6,2451.6,2439,2439,12.6,12.6,0,0,0,0\r\n" +
            "ACCAL202303210822822738124754328,1,1,20230421,20230421,1,2734.05,2734.05,2720,2720,14.05,14.05,0,0,0,0\r\n" +
            "ACCAL202303210822889804051664280,1,1,20230421,20230421,1,1769.09,1769.09,1760,1760,9.09,9.09,0,0,0,0\r\n" +
            "ACCAL202303210822889978270618500,1,1,20230421,20230421,1,1986.21,1986.21,1976,1976,10.21,10.21,0,0,0,0\r\n" +
            "ACCAL202303210822890101356657412,1,1,20230421,20230421,1,4106.31,4106.31,4085.2,4085.2,21.11,21.11,0,0,0,0\r\n" +
            "ACCAL202303210822890249516251908,1,1,20230421,20230421,1,2794.36,2794.36,2780,2780,14.36,14.36,0,0,0,0\r\n" +
            "ACCAL202303220823203056275198852,1,1,20230421,20230421,1,4775.76,4775.76,4752,4752,23.76,23.76,0,0,0,0\r\n" +
            "ACCAL202303220823203195790183832,1,1,20230421,20230421,1,4743.6,4743.6,4720,4720,23.6,23.6,0,0,0,0\r\n" +
            "ACCAL202303230823489187013092948,1,1,20230421,20230421,1,7797.51,7797.51,7760,7760,37.51,37.51,0,0,0,0\r\n" +
            "ACCAL202303240823906218455893408,1,1,20230421,20230421,1,2461.43,2461.43,2450,2450,11.43,11.43,0,0,0,0\r\n" +
            "ACCAL202303240823906429345358304,1,1,20230421,20230421,1,2461.43,2461.43,2450,2450,11.43,11.43,0,0,0,0\r\n" +
            "ACCAL202303240823953729795017596,1,1,20230421,20230421,1,7796.21,7796.21,7760,7760,36.21,36.21,0,0,0,0\r\n" +
            "ACCAL202303270825010819787547104,1,1,20230421,20230421,1,3070.34,3070.34,3057.6,3057.6,12.74,12.74,0,0,0,0\r\n" +
            "ACCAL202303270825010958337991136,1,1,20230421,20230421,1,12803.13,12803.13,12750,12750,53.13,53.13,0,0,0,0\r\n" +
            "ACCAL202303270825011269215603580,1,1,20230421,20230421,1,3946.38,3946.38,3930,3930,16.38,16.38,0,0,0,0\r\n" +
            "ACCAL202303280825368044720775648,1,1,20230421,20230421,1,6598.29,6598.29,6572,6572,26.29,26.29,0,0,0,0\r\n" +
            "ACCAL202303280825368310589462880,1,1,20230421,20230421,1,3508.38,3508.38,3494.4,3494.4,13.98,13.98,0,0,0,0\r\n" +
            "ACCAL202304010826813700408905968,1,1,20230513,20230513,1,11310.62,11310.62,11232,11232,0,0,0,0,78.62,78.62\r\n" +
            "ACCAL202304010826815943283608564,1,1,20230513,20230513,1,50601.75,50601.75,50250,50250,0,0,0,0,351.75,351.75\r\n" +
            "ACCAL202304030827497259003954472,1,1,20230513,20230513,1,10509.6,10509.6,10440,10440,0,0,0,0,69.6,69.6\r\n" +
            "ACCAL202304030827508922432385384,1,2,20230418,20230418,1,169.4,169.4,110,110,0,0,0,0,59.4,59.4\r\n" +
            "ACCAL202304030827508922432385384,1,2,20230513,20230513,1,23748.54,23748.54,23650,23650,0,0,0,0,98.54,98.54\r\n" +
            "ACCAL202304030827540630472901928,1,1,20230515,20230515,1,10360.02,10360.02,10288,10288,0,0,0,0,72.02,72.02\r\n" +
            "ACCAL202304030827540818721804768,1,1,20230515,20230515,1,8680.34,8680.34,8620,8620,0,0,0,0,60.34,60.34\r\n" +
            "ACCAL202304030827541273149477344,1,1,20230515,20230515,1,1852.88,1852.88,1840,1840,0,0,0,0,12.88,12.88\r\n" +
            "ACCAL202304030827541518256211240,1,1,20230515,20230515,1,6959.88,6959.88,6911.5,6911.5,0,0,0,0,48.38,48.38\r\n" +
            "ACCAL202304030827575088907584808,1,1,20230513,20230513,1,20234,20234,20100,20100,0,0,0,0,134,134\r\n" +
            "ACCAL202304030827583837898434312,1,1,20230515,20230515,1,1760.24,1760.24,1748,1748,0,0,0,0,12.24,12.24\r\n" +
            "ACCAL202304030827584024025002344,1,1,20230515,20230515,1,2044.21,2044.21,2030,2030,0,0,0,0,14.21,14.21\r\n" +
            "ACCAL202304030827588805720311080,1,1,20230515,20230515,1,2831.07,2831.07,2811.39,2811.39,0,0,0,0,19.68,19.68\r\n" +
            "ACCAL202304030827596631729390888,1,1,20230513,20230513,1,10283.1,10283.1,10215,10215,0,0,0,0,68.1,68.1\r\n" +
            "ACCAL202304030827613790450902792,1,1,20230513,20230513,1,2287.15,2287.15,2272,2272,0,0,0,0,15.15,15.15\r\n" +
            "ACCAL202304040827923602158154088,1,1,20230515,20230515,1,3171.53,3171.53,3150,3150,0,0,0,0,21.53,21.53\r\n" +
            "ACCAL202304040827923828486992232,1,1,20230515,20230515,1,12736.44,12736.44,12650,12650,0,0,0,0,86.44,86.44\r\n" +
            "ACCAL202304040827926225103766824,1,1,20230515,20230515,1,1385.4,1385.4,1376,1376,0,0,0,0,9.4,9.4\r\n" +
            "ACCAL202304040827926669993592104,1,1,20230515,20230515,1,8384.91,8384.91,8328,8328,0,0,0,0,56.91,56.91\r\n" +
            "ACCAL202304040827927239336953128,1,1,20230515,20230515,1,9008.14,9008.14,8947,8947,0,0,0,0,61.14,61.14\r\n" +
            "ACCAL202304040827927484296750856,1,1,20230515,20230515,1,5185.19,5185.19,5150,5150,0,0,0,0,35.19,35.19\r\n" +
            "ACCAL202304040827927595575821608,1,1,20230515,20230515,1,7198.86,7198.86,7150,7150,0,0,0,0,48.86,48.86\r\n" +
            "ACCAL202304060828561163260036392,1,1,20230513,20230513,1,3426,3426,3405,3405,0,0,0,0,21,21\r\n" +
            "ACCAL202304060828580814891144428,1,1,20230515,20230515,1,3774.38,3774.38,3750,3750,0,0,0,0,24.38,24.38\r\n" +
            "ACCAL202304110830375878613299560,1,1,20230515,20230515,1,6000.81,6000.81,5967,5967,0,0,0,0,33.81,33.81\r\n" +
            "ACCAL202304110830376091025442088,1,1,20230515,20230515,1,2031.45,2031.45,2020,2020,0,0,0,0,11.45,11.45\r\n" +
            "ACCAL202304110830376238639777064,1,1,20230515,20230515,1,4525.5,4525.5,4500,4500,0,0,0,0,25.5,25.5\r\n" +
            "ACCAL202304110830376491703103848,1,1,20230515,20230515,1,6914.96,6914.96,6876,6876,0,0,0,0,38.96,38.96\r\n" +
            "ACCAL202304110830385437360678664,1,2,20230418,20230418,1,211.15,211.15,82,82,0,0,0,0,129.15,129.15\r\n" +
            "ACCAL202304110830385437360678664,1,2,20230513,20230513,1,111078.91,111078.91,110618,110618,0,0,0,0,460.91,460.91\r\n" +
            "ACCAL202304110830391494770459944,1,1,20230513,20230513,1,2284.12,2284.12,2272,2272,0,0,0,0,12.12,12.12\r\n" +
            "ACCAL202304110830440482706064680,1,1,20230513,20230513,1,24248.64,24248.64,24120,24120,0,0,0,0,128.64,128.64\r\n" +
            "ACCAL202304110830467027851957484,1,1,20230513,20230513,1,2505.29,2505.29,2492,2492,0,0,0,0,13.29,13.29\r\n" +
            "ACCAL202304110830490421242925536,1,1,20230513,20230513,1,50331.01,50331.01,50064,50064,0,0,0,0,267.01,267.01\r\n" +
            "ACCAL202304120830748651013575136,1,1,20230515,20230515,1,3663.54,3663.54,3643.5,3643.5,0,0,0,0,20.04,20.04\r\n" +
            "ACCAL202304120830749087732754184,1,1,20230515,20230515,1,4113.1,4113.1,4090.6,4090.6,0,0,0,0,22.5,22.5\r\n" +
            "ACCAL202304120830749200114930924,1,1,20230515,20230515,1,5249.29,5249.29,5220.58,5220.58,0,0,0,0,28.71,28.71\r\n" +
            "ACCAL202304120830756939776165160,1,1,20230515,20230515,1,1240.99,1240.99,1234.2,1234.2,0,0,0,0,6.79,6.79\r\n" +
            "ACCAL202304120830767053782271272,1,1,20230513,20230513,1,4113.19,4113.19,4092.05,4092.05,0,0,0,0,21.14,21.14\r\n" +
            "ACCAL202304120830814966738883040,1,1,20230513,20230513,1,2533.02,2533.02,2520,2520,0,0,0,0,13.02,13.02\r\n" +
            "ACCAL202304120830825006581453280,1,1,20230515,20230515,1,2366.95,2366.95,2354,2354,0,0,0,0,12.95,12.95\r\n" +
            "ACCAL202304130831134774327923948,1,1,20230513,20230513,1,2613,2613,2600,2600,0,0,0,0,13,13\r\n" +
            "ACCAL202304140831452272160181416,1,1,20230515,20230515,1,4796.66,4796.66,4772,4772,0,0,0,0,24.66,24.66\r\n" +
            "ACCAL202304140831452383862886400,1,1,20230515,20230515,1,6332.55,6332.55,6300,6300,0,0,0,0,32.55,32.55\r\n" +
            "ACCAL202304140831483276492958468,1,1,20230513,20230513,1,6631.9,6631.9,6600,6600,0,0,0,0,31.9,31.9\r\n" +
            "ACCAL202304170832595945279229952,1,1,20230515,20230515,1,3309.37,3309.37,3294,3294,0,0,0,0,15.37,15.37\r\n" +
            "ACCAL202304170832596107875618816,1,1,20230515,20230515,1,7721.87,7721.87,7686,7686,0,0,0,0,35.87,35.87\r\n" +
            "ACCAL202304170832653262116916392,1,1,20230515,20230515,1,4119.13,4119.13,4100,4100,0,0,0,0,19.13,19.13\r\n" +
            "ACCAL202304170832653441645567324,1,1,20230515,20230515,1,1431.88,1431.88,1425.23,1425.23,0,0,0,0,6.65,6.65\r\n" +
            "ACCAL202304170832653623384752788,1,1,20230515,20230515,1,2973.81,2973.81,2960,2960,0,0,0,0,13.81,13.81\r\n" +
            "ACCAL202304170832653862711889064,1,1,20230515,20230515,1,9790.48,9790.48,9745,9745,0,0,0,0,45.48,45.48\r\n" +
            "ACCAL202304170832654024137923932,1,1,20230515,20230515,1,4269.83,4269.83,4250,4250,0,0,0,0,19.83,19.83\r\n" +
            "ACCAL202304170832654184247234560,1,1,20230515,20230515,1,5035.19,5035.19,5011.8,5011.8,0,0,0,0,23.39,23.39\r\n" +
            "ACCAL202304170832654321963011240,1,1,20230515,20230515,1,1757.76,1757.76,1749.6,1749.6,0,0,0,0,8.16,8.16\r\n" +
            "ACCAL202304170832654610589707012,1,2,20230424,20230424,1,239.39,239.39,224.82,224.82,0,0,0,0,14.57,14.57\r\n" +
            "ACCAL202304170832654610589707012,1,2,20230515,20230515,1,12308.11,12308.11,12265.18,12265.18,0,0,0,0,42.93,42.93\r\n" +
            "ACCAL202304170832664330973113092,1,1,20230513,20230513,1,10666.02,10666.02,10620,10620,0,0,0,0,46.02,46.02\r\n" +
            "ACCAL202304170832664676080435860,1,1,20230513,20230513,1,21512.82,21512.82,21420,21420,0,0,0,0,92.82,92.82\r\n" +
            "ACCAL202304170832672799113495188,1,1,20230513,20230513,1,5041.75,5041.75,5020,5020,0,0,0,0,21.75,21.75\r\n" +
            "ACCAL202304180833002050648045560,1,1,20230513,20230513,1,1482.15,1482.15,1476,1476,0,0,0,0,6.15,6.15\r\n" +
            "ACCAL202304190833292582305553756,1,1,20230515,20230515,1,1918.28,1918.28,1910,1910,0,0,0,0,8.28,8.28\r\n" +
            "ACCAL202304190833292720801464980,1,1,20230515,20230515,1,1757.58,1757.58,1750,1750,0,0,0,0,7.58,7.58\r\n" +
            "ACCAL202304190833293046153777152,1,1,20230515,20230515,1,2145.26,2145.26,2136,2136,0,0,0,0,9.26,9.26\r\n" +
            "ACCAL202304190833293142316584960,1,1,20230515,20230515,1,2430.49,2430.49,2420,2420,0,0,0,0,10.49,10.49\r\n" +
            "ACCAL202304190833365744774955668,1,1,20230513,20230513,1,1358.91,1358.91,1353.5,1353.5,0,0,0,0,5.41,5.41\r\n" +
            "ACCAL202304190833375292583730524,1,1,20230513,20230513,1,5844.48,5844.48,5821.2,5821.2,0,0,0,0,23.28,23.28\r\n" +
            "ACCAL202304200833727044256426756,1,1,20230515,20230515,1,9399,9399,9360,9360,0,0,0,0,39,39\r\n" +
            "ACCAL202304200833727205326223352,1,1,20230515,20230515,1,1656.88,1656.88,1650,1650,0,0,0,0,6.88,6.88\r\n" +
            "ACCAL202304200833748272702702228,1,1,20230515,20230515,1,4920.42,4920.42,4900,4900,0,0,0,0,20.42,20.42\r\n" +
            "ACCAL202304210834088035121142952,1,1,20230513,20230513,1,6202.66,6202.66,6180,6180,0,0,0,0,22.66,22.66\r\n" +
            "ACCAL202304210834089730752276832,1,1,20230513,20230513,1,6207.68,6207.68,6185,6185,0,0,0,0,22.68,22.68\r\n" +
            "ACCAL202304210834104014089780272,1,1,20230515,20230515,1,3533.08,3533.08,3519,3519,0,0,0,0,14.08,14.08\r\n" +
            "ACCAL202304210834104841583880544,1,1,20230515,20230515,1,5973.8,5973.8,5950,5950,0,0,0,0,23.8,23.8\r\n" +
            "ACCAL202304210834105113467049376,1,1,20230515,20230515,1,1757,1757,1750,1750,0,0,0,0,7,7\r\n" +
            "ACCAL202304210834105252764079520,1,1,20230515,20230515,1,1433.71,1433.71,1428,1428,0,0,0,0,5.71,5.71\r\n" +
            "ACCAL202304210834108301616237676,1,1,20230515,20230515,1,1224.88,1224.88,1220,1220,0,0,0,0,4.88,4.88\r\n" +
            "ACCAL202304210834117036120107360,1,1,20230513,20230513,1,8099.59,8099.59,8070,8070,0,0,0,0,29.59,29.59\r\n" +
            "ACCAL202304220834392217535421608,1,1,20230513,20230513,1,2157.53,2157.53,2150,2150,0,0,0,0,7.53,7.53\r\n" +
            "ACCAL202304230834734865907489960,1,1,20230515,20230515,1,7798.49,7798.49,7770,7770,0,0,0,0,28.49,28.49\r\n" +
            "ACCAL202304230834735312655240300,1,1,20230515,20230515,1,7127.04,7127.04,7101,7101,0,0,0,0,26.04,26.04\r\n" +
            "ACCAL202304230834735473683102768,1,1,20230515,20230515,1,3536.42,3536.42,3523.5,3523.5,0,0,0,0,12.92,12.92\r\n" +
            "ACCAL202304230834735634064901656,1,1,20230515,20230515,1,6612.16,6612.16,6588,6588,0,0,0,0,24.16,24.16\r\n" +
            "ACCAL202304230834735775580580192,1,1,20230515,20230515,1,4516.5,4516.5,4500,4500,0,0,0,0,16.5,16.5\r\n" +
            "ACCAL202304250835463645378532768,1,1,20230515,20230515,1,1956.5,1956.5,1950,1950,0,0,0,0,6.5,6.5\r\n" +
            "ACCAL202304250835463804468483488,1,1,20230515,20230515,1,5562.48,5562.48,5544,5544,0,0,0,0,18.48,18.48\r\n" +
            "ACCAL202304250835463930729760280,1,1,20230515,20230515,1,1812.32,1812.32,1806.3,1806.3,0,0,0,0,6.02,6.02\r\n" +
            "ACCAL202304250835464055665490992,1,1,20230515,20230515,1,1318.38,1318.38,1314,1314,0,0,0,0,4.38,4.38\r\n" +
            "ACCAL202304250835464177207889004,1,1,20230515,20230515,1,13839.98,13839.98,13794,13794,0,0,0,0,45.98,45.98\r\n" +
            "ACCAL202304250835464300465908064,1,1,20230515,20230515,1,3736.51,3736.51,3724.1,3724.1,0,0,0,0,12.41,12.41\r\n" +
            "ACCAL202304250835464430254595240,1,1,20230515,20230515,1,1775.9,1775.9,1770,1770,0,0,0,0,5.9,5.9\r\n" +
            "ACCAL202304250835531276018285616,1,1,20230513,20230513,1,54595.3,54595.3,54432,54432,0,0,0,0,163.3,163.3\r\n" +
            "ACCAL202304250835547971260808240,1,1,20230513,20230513,1,1487.45,1487.45,1483,1483,0,0,0,0,4.45,4.45\r\n" +
            "ACCAL202304260835828157046739844,1,2,20230512,20230512,1,111.1,111.1,12.8,12.8,0,0,0,0,98.3,98.3\r\n" +
            "ACCAL202304260835828157046739844,1,2,20230513,20230513,1,36857.34,36857.34,36851.2,36851.2,0,0,0,0,6.14,6.14\r\n" +
            "ACCAL202304260835860841005475592,1,1,20230515,20230515,1,3306.44,3306.44,3296,3296,0,0,0,0,10.44,10.44\r\n" +
            "ACCAL202304260835897056178099076,1,1,20230515,20230515,1,3591.34,3591.34,3580,3580,0,0,0,0,11.34,11.34\r\n" +
            "ACCAL202304260835943779340543752,1,1,20230513,20230513,1,5902.68,5902.68,5886,5886,0,0,0,0,16.68,16.68\r\n" +
            "ACCAL202304270836186578434694432,1,1,20230513,20230513,1,16995.2,16995.2,16950,16950,0,0,0,0,45.2,45.2\r\n" +
            "ACCAL202304270836209245522908036,1,1,20230513,20230513,1,50985.6,50985.6,50850,50850,0,0,0,0,135.6,135.6\r\n" +
            "ACCAL202304270836270517501336864,1,2,20230512,20230512,1,135.93,135.93,99.95,99.95,0,0,0,0,35.98,35.98\r\n" +
            "ACCAL202304270836270517501336864,1,2,20230513,20230513,1,14295.23,14295.23,14292.85,14292.85,0,0,0,0,2.38,2.38\r\n" +
            "ACCAL202304270836271105576303784,1,1,20230513,20230513,1,12248.58,12248.58,12216,12216,0,0,0,0,32.58,32.58\r\n" +
            "ACCAL202304270836271331804342024,1,1,20230513,20230513,1,8855.55,8855.55,8832,8832,0,0,0,0,23.55,23.55\r\n" +
            "ACCAL202304280836625112425452420,1,1,20230513,20230513,1,10025,10025,10000,10000,0,0,0,0,25,25\r\n" +
            "ACCAL202304280836641357552188584,1,1,20230513,20230513,1,16180.35,16180.35,16140,16140,0,0,0,0,40.35,40.35\r\n" +
            "ACCAL202304280836650609746267304,1,1,20230513,20230513,1,1371.43,1371.43,1368.01,1368.01,0,0,0,0,3.42,3.42\r\n" +
            "ACCAL202304290836984219225443496,1,1,20230515,20230515,1,26192.41,26192.41,26122.75,26122.75,0,0,0,0,69.66,69.66\r\n" +
            "ACCAL202304110830378761350063640,1,1,20230515,20230515,1,13516.16,13516.16,13440,13440,0,0,0,0,76.16,76.16\r\n" +
            "ACCAL202304110830460573212379308,1,1,20230515,20230515,1,2901.65,2901.65,2885.3,2885.3,0,0,0,0,16.35,16.35\r\n" +
            "ACCAL202304120830835868964647632,1,1,20230515,20230515,1,2068.31,2068.31,2057,2057,0,0,0,0,11.31,11.31\r\n" +
            "ACCAL202304180833006754153004020,1,1,20230515,20230515,1,2164.2,2164.2,2154.5,2154.5,0,0,0,0,9.7,9.7\r\n" +
            "ACCAL202304180833007101680600000,1,1,20230515,20230515,1,14127.29,14127.29,14064,14064,0,0,0,0,63.29,63.29\r\n" +
            "ACCAL202304180833007276444515316,1,1,20230515,20230515,1,2591.81,2591.81,2580.2,2580.2,0,0,0,0,11.61,11.61\r\n" +
            "ACCAL202304190833360520106787776,1,1,20230515,20230515,1,4449.4,4449.4,4430.2,4430.2,0,0,0,0,19.2,19.2\r\n" +
            "ACCAL202304200833723228601616136,1,1,20230515,20230515,1,2244.31,2244.31,2235,2235,0,0,0,0,9.31,9.31\r\n" +
            "ACCAL202304200833793030309452728,1,1,20230516,20230516,1,598.08,598.08,595.5,595.5,0.1,0.1,0,0,2.48,2.48\r\n" +
            "ACCAL202304250835538662204283832,1,1,20230515,20230515,1,22241.19,22241.19,22167.3,22167.3,0,0,0,0,73.89,73.89\r\n" +
            "ACCAL202304260835904000406371196,1,1,20230515,20230515,1,1804.04,1804.04,1798.35,1798.35,0,0,0,0,5.69,5.69\r\n" +
            "ACCAL202304270836164870877258388,1,1,20230515,20230515,1,2868.58,2868.58,2860,2860,0,0,0,0,8.58,8.58\r\n" +
            "ACCAL202304280836644033748837012,1,1,20230515,20230515,1,1078.05,1078.05,1075,1075,0,0,0,0,3.05,3.05\r\n" +
            "ACCAL202304280836659144831964216,1,1,20230515,20230515,1,2791.39,2791.39,2783.5,2783.5,0,0,0,0,7.89,7.89\r\n" +
            "ACCAL202304110830506392921896472,1,1,20230513,20230513,1,1470.2,1470.2,1462.4,1462.4,0,0,0,0,7.8,7.8\r\n" +
            "ACCAL202304190833456345092776236,1,1,20230513,20230513,1,3976.84,3976.84,3961,3961,0,0,0,0,15.84,15.84\r\n" +
            "ACCAL202304260835848590617917672,1,1,20230513,20230513,1,1444.08,1444.08,1440,1440,0,0,0,0,4.08,4.08\r\n" +
            "ACCAL202304280836569659603591588,1,1,20230513,20230513,1,2257.63,2257.63,2252,2252,0,0,0,0,5.63,5.63\r\n" +
            "ACCAL202305040838716100241586948,1,1,20230513,20230513,1,3441.96,3441.96,3436.8,3436.8,0,0,0,0,5.16,5.16";

}
